Stclements1
Board Regular
- Joined
- Sep 15, 2018
- Messages
- 150
- Office Version
- 365
- Platform
- Windows
I am currently using this formula to provide end of month dates which works perfectly but what I want to do in addition is to make the output to be networkdays only but I cannot workout where I need to add this within the formula to make that happen.
=IF(ROWS(E$2:E2)>($B$4*12);"";EOMONTH(TRIM($B$2);ROWS(E$2:E2)-1))
In addition to this in cell B2 is it possible to have a date format that will let an end user type in a date in dd/mm/yyyy format and get a long date output. when I use the date function it wants me to input in this order yy/mm/dd
=IF(ROWS(E$2:E2)>($B$4*12);"";EOMONTH(TRIM($B$2);ROWS(E$2:E2)-1))
In addition to this in cell B2 is it possible to have a date format that will let an end user type in a date in dd/mm/yyyy format and get a long date output. when I use the date function it wants me to input in this order yy/mm/dd