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

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

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

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

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

sorry , I meant:

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

What's is wrong with this?

Add

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

to the end of the remaining days calculation.

Thanks Queue,

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

Any thoughts?

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