Hi guys,

Two questions:

1) Is there some simple way to show number of days in a month based on current day of the month ?

What I mean is that I want to have a cell in which I will be having number of days displayed dynamically. For example today it would be 31, in January on any given day it would be 31, on February on any given day it would be 28 etc.,

One way I found is to have a formula like this "=DAY(MONTH(TODAY()))" which displays a value from 1-12 obviously, and then I can do an IFS function that determines cell value (from 28 to 31) based on values from the formula (1 to 12). However, there must be a much simpler way.

2) Is there a way to do the same thing but having number of working days displayed in the month ? or some criteria ? I count that Saturday is a working day.

I'd much appreciate!
vemix