field to show remaining woking days in month

[robert J Collins]

I am trying to set up a couple of fields to show information based on the current month

field A) to show number of working days in current month (based on 6 working days a week- in other words excluding Sundays)

field : to show remaining number of working days in current month (again 6 day week excluding Sundays)

(again!) any help appreciated

[-Queue-]

Well that was fun! See attached for what appears to be a working version of your requirements. I also included the combined calculations, in case you only want to add two fields instead of six.

WorkingDays.zip

[robert J Collins]

Thanks Queue, I was beginning to think I was asking the impossible.

I very much appreciate your help and time on this on.

thanks again

[Lee Smith]

Now all you need to do is to figure how you can adjust the calculations for a holiday. Although working 6 days a week may mean that there ain't no holidays (except Sundays).

For a hint of what I mean, take a look at this Sample file by Bob Weaver called Workdays and located here:

http://www.fmforums.com/forum/showtopic.php?tid/54679/

Lee

[robert J Collins]

I would like to add one more calculation to this

If the current time is before 4pm , add 1 day to the total number of working days left (so that it includes today) if not leave the total number of days as is.

I am nearly there, but could someone correct this line for me.

I am going to add one more field called "Timecutoff " which will be a calculated result

If (current time) <16.00 ; combinedRemainingWorkingDays +1 ; combinedRemainingWorkingDays

thanks

[robert J Collins]

sorry , I meant:

If(Status(CurrentTime) < "4:00:00 pm" ; CombinedRemainingWorkingDays + 1; CombinedRemainingWorkingDays)

What's is wrong with this?

[-Queue-]

Add

+ (Status(CurrentTime) < Time( 16, 00, 00 ))

to the end of the remaining days calculation.

[robert J Collins]

Thanks Queue,

when I do that the last 4 zeros are highlighted and I get the message field not found

Any thoughts?

[robert J Collins]

sorry, I found the problem - I was using instead of ;