IF functions with dates [Solved/Closed]

Report
Posts
2
Registration date
Thursday September 24, 2015
Status
Member
Last seen
September 24, 2015
-
Posts
2
Registration date
Thursday September 24, 2015
Status
Member
Last seen
September 24, 2015
-
Hi,
I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece of data rather than using formulas.
I'm trying to idiot proof everything so that they don't have to waste so much time anymore.
Right now I am working on a workbook they have that they print out every other week, previously they had to manually change all the dates (on 42 pages). I have it now so that if the workbook is printed on the day before they are needed (Sunday) all they need to do it open it up and print, just using TODAY()+1 and so on

I am trying to an IF function to idiot proof it so if they have to print it on a Monday for whatever reason the dates will be correct. Just a proviso, if the work isn't printed on the Sunday, it absolutely must be printed on the Monday.

I tried today using this function as a test

=IF(WEEKDAY(TODAY())=1,(TODAY()+1),IF(WEEKDAY(TODAY())=4,(TODAY()),""))

Obviously I would have changed the 4 to a 2 had it worked, however it gave me the following value

42270

Which somehow is equal to 9/23/2015, I have no idea why.

I am trying to show my regional manager that I can make the admin work more efficient, any help would be greatly appreciated






1 reply

Posts
2
Registration date
Thursday September 24, 2015
Status
Member
Last seen
September 24, 2015

I received a reply on another forum informing me that 42270 is how excel sees the date as a number. I formatted the cell to show the date and it worked.